Tabela LServicePatMaterial4Coding

Definicja tabeli LServicePatMaterial4Coding

Name

LServicePatMaterial4Coding

Code

LServicePatMaterial4Coding

Comment

 


Lista kolumn tabeli LServicePatMaterial4Coding

Name

Code

LServicePatMaterial4CodingID

LServicePatMaterial4CodingID

ServID

ServID

CodingServID

CodingServID

PatMaterialTypeID

PatMaterialTypeID

MinCount

MinCount

MaxCount

MaxCount


Kolumna LServicePatMaterial4CodingID tabeli LServicePatMaterial4Coding

Definicja kolumny LServicePatMaterial4CodingID tabeli LServicePatMaterial4Coding

Name

LServicePatMaterial4CodingID

Code

LServicePatMaterial4CodingID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServID tabeli LServicePatMaterial4Coding

Definicja kolumny ServID tabeli LServicePatMaterial4Coding

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID uslugi


Kolumna CodingServID tabeli LServicePatMaterial4Coding

Definicja kolumny CodingServID tabeli LServicePatMaterial4Coding

Name

CodingServID

Code

CodingServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

id uslugi do zakodowania (po spelnieniu kryteriów)


Kolumna PatMaterialTypeID tabeli LServicePatMaterial4Coding

Definicja kolumny PatMaterialTypeID tabeli LServicePatMaterial4Coding

Name

PatMaterialTypeID

Code

PatMaterialTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna MinCount tabeli LServicePatMaterial4Coding

Definicja kolumny MinCount tabeli LServicePatMaterial4Coding

Name

MinCount

Code

MinCount

Data Type

NUMBER(5)

Mandatory

No

Comment

Ilosc od której zliczac wystapienia (np. dla MinCount=3 przy 5 bloczkach zakoduj 3 wystapienia uslugi)


Kolumna MaxCount tabeli LServicePatMaterial4Coding

Definicja kolumny MaxCount tabeli LServicePatMaterial4Coding

Name

MaxCount

Code

MaxCount

Data Type

NUMBER(5)

Mandatory

No

Comment

Ilosc do której zliczac wystapienia (np.dla MinCount=3 i MaxCount=5 przy 7 bloczkach zakoduj 3 wystapienia uslugi)


Lista kluczy tabeli LServicePatMaterial4Coding

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LServicePatMaterial4Coding

Definicja klucza Identifier_1 tabeli LServicePatMaterial4Coding

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment